/*******************************************************************************
 * This file is part of blueprint4j www.blueprint4j.org.
 * 
 *     blueprint4j is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU Lesser General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 * 
 *     blueprint4j is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Lesser General Public License for more details.
 * 
 *     You should have received a copy of the GNU Lesser General Public License
 *     along with blueprint4j. If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package blueprint4j.db;

import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class VectorFieldBlob {
	private Vector store=new Vector();

	public FieldBlob get(int pos){
		return (FieldBlob)store.get(pos);
	}
	
	public void add(FieldBlob item){
		store.add(item);
	}
	
	public boolean remove(FieldBlob item){
		return store.remove(item);
	}

	public FieldBlob remove(int pos){
		return (FieldBlob) store.remove(pos);
	}
	
	public int size(){
		return store.size();
	}
	
	public void setSQLValue(ResultSet rs) throws SQLException {
		for (int i =0;i < size();i++) {
			get(i).setSQLValue(rs);
		}
	}
	
	public void update(DBConnection dbcon,String tablename,String where) 
	throws SQLException,IOException {
		if (size() == 0) {
			return;
		}
		String sqlupdate = "update " + tablename + " set ";
		for (int i = 0;i < size();i++) {
			sqlupdate += get(i).getName() + " = ?";
			if (i < size()-1) {
				sqlupdate += ",";
			}
		}
		sqlupdate += " where " + where;
		PreparedStatement ps = dbcon.prepareStatement(sqlupdate);
		for (int i = 0;i < size();i++) {
			ps.setBytes(i+1,get(i).getObjectAsBytes());
		}
		ps.execute();
	}

}

